Database Systems: Concepts, Design and Applications by Shio Kumar Singh

Author:Shio Kumar Singh [Singh, Shio Kumar]
Language: eng
Format: azw3
ISBN: 9789332503212
Publisher: Pearson India
Published: 2011-07-31T16:00:00+00:00

FILL IN THE BLANKS

Transaction is a _____ of work that represents real-world events of any organisation or an enterprise, whereas concurrency control is the management of concurrent transaction execution.

_____ is the activity of coordinating the actions of processes that operate in parallel, access shared data, and therefore potentially interfere with each other.

A simple way to detect a state of deadlock is for the system to construct and maintain a _____ graph.

A transaction is a sequence of _____ and _____ actions that are grouped together to from a database access.

_____ is the ability of a DBMS to manage the various transactions that occur within the system.

Atomic transaction is a transaction in which either _____ with the transaction are executed to completion or are performed.

The ACID properties of a transaction are (a) _____, (b) _____, (c) _____ and (d) _____.

_____ means that execution of a transaction in isolation preserves the consistency of the database.

The _____ of the DBMS ensures the atomicity of each transaction.

Transaction log is a _____ of all _____ and the corresponding changes to the _____.

Ensuring durability is the responsibility of the _____ of the DBMS.

Isolation property of transaction means that the data used during the execution of a transaction cannot be used by _____ until the first one is completed.

A consistent database state is one in which all _____ constraints are satisfied.

A transaction that changes the contents of the database must alter the database from one _____ to another.

The isolation property is the responsibility of the _____ of DBMS.

A transaction that completes its execution successfully is said to be _____.

Level 2 transaction consistency isolates from the _____ of other transactions.

When a transaction has not successfully completed its execution we say that it has _____.

A _____ is a schedule where the operations from a group of concurrent transactions are interleaved.

The objective of _____ is to find non-serial schedules.

The situation where a single transaction failure leads to a series of rollbacks is called a _____.

_____ is the size of the data item chosen as the unit of protection by a concurrency control program.

Optimistic concurrency control techniques are also called _____ concurrency scheme.

The only way to undo the effects of a committed transaction is to execute a _____.

Collections of operations that form a single logical unit of work are called _____.

Serialisability must be guaranteed to prevent _____ from transactions interfering with one another.

Precedence graph is used to depict _____.

Lock prevents access to a _____ by a second transaction until the first transaction has completed all of its actions.

A shared/exclusive (or Read/Write) lock uses _____ lock.

A shared lock exists when concurrent transactions are granted _____ access on the basis of a common lock.

Two-phase locking is a method of controlling _____ in which all locking operations precede the first unlocking operation.

In a growing phase, a transaction acquires all the required locks without _____ any data.

In a shrinking phase, a transaction releases _____ and cannot obtain any _____ lock.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.